UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5dAVhJYOjnkDddu1slbK2GPsC1FOIaZ2XbvQgt3XEU='
WHERE
key_id = '7b307f1815360504dca02a2477489e50134470da714811f578894944b61557a3'
AND (
token = 'B5dAVhJYOjnkDddu1slbK2GPsC1FOIaZ2XbvQgt3XEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)