UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qGYXjfd1onJjClhnQAONKaEW8IlVfefw5kjecadxB9U='
WHERE
key_id = 'a8d5842a137d6f2df5729f744bda48da61792b04bc080968ee366ae7955feb5a'
AND (
token = 'qGYXjfd1onJjClhnQAONKaEW8IlVfefw5kjecadxB9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)