UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YYofo2ESY9ql02l6XOY7cwyOoe+vMhwOj9sYhTynDmA='
WHERE
key_id = '6bc965235090d299184d2b7f368c1d27c3cac8a9400807678e53bff82ddd787c'
AND (
token = 'YYofo2ESY9ql02l6XOY7cwyOoe+vMhwOj9sYhTynDmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)