UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GpiZ/NliaxbAI2mrGxlJX+7Z+gFVMrDbUwIjD0eEJy0='
WHERE
key_id = 'a5a39c2f3f67409bb8b5854650b9d4b7807c5b14ac1bc3d82718dc8151ef7b26'
AND (
token = 'GpiZ/NliaxbAI2mrGxlJX+7Z+gFVMrDbUwIjD0eEJy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)