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