UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XP8oou9JG76T9+++HYBeL9lAuK+tJBxa87rRf6IPmvg='
WHERE
key_id = '72746d8fd63eb01795aa8122d7b83b7bd3a2428743a0c1060428597d60fc4cc5'
AND (
token = 'XP8oou9JG76T9+++HYBeL9lAuK+tJBxa87rRf6IPmvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)