UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKaJdbO4JZfvRVagmjA/gkq3HiP11xjjZnIR73bjyFw='
WHERE
key_id = 'd84abc0a0f55dfdddb14f83a5c4b1fa8679c97eec0d005a2cab4018ab1a3491c'
AND (
token = 'xKaJdbO4JZfvRVagmjA/gkq3HiP11xjjZnIR73bjyFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)