UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcAhFKy6jFpoEpELYPbeQkDLQf0RPeJXa+ADQ1XHHkM='
WHERE
key_id = 'a534a7b1a90c0d0acd9cc67be03ef41e4d9c3a7c3aaa7c0eb3a5ec6c6afdfbc0'
AND (
token = 'zcAhFKy6jFpoEpELYPbeQkDLQf0RPeJXa+ADQ1XHHkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)