UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QzyrqyaGKAPehFU41lU/0Cl50SJSTr3tUL2ZHH8yvOI='
WHERE
key_id = 'a7e97e79c0b48cc1396d05e9081ce5b6c26d02d310c0b2843a2e809080e1bb1c'
AND (
token = 'QzyrqyaGKAPehFU41lU/0Cl50SJSTr3tUL2ZHH8yvOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)