UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SVzsRXV5U9bAaD+lhwZIeUYxBfevC+1xaMOWrCwNm6Y='
WHERE
key_id = 'e60563e004a8d72eddc74754a252c1b745e226c92d2e3f8a45bb7dc70dee2c78'
AND (
token = 'SVzsRXV5U9bAaD+lhwZIeUYxBfevC+1xaMOWrCwNm6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)