UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vk4deCOIzikFWgX0YnYco41yYxai0hCuE5KfXAiRes='
WHERE
key_id = 'a28520c768124af9dbd12bd75c2551b02e785b6889cb0a7d43671fa727ef5216'
AND (
token = '2vk4deCOIzikFWgX0YnYco41yYxai0hCuE5KfXAiRes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)