UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnPsM/xRKVCXl4jp2tJd7x0PFFbTF66iu7UPUjmCjxM='
WHERE
key_id = '4b46575b744ed7b0f2c274f6812ce6f0c1ebe539cc5907197482a019c82e1ebf'
AND (
token = 'TnPsM/xRKVCXl4jp2tJd7x0PFFbTF66iu7UPUjmCjxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)