UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcJjY703NqEGDzsBpd7icKIBW7bL3Su0Dbo0N+HID8c='
WHERE
key_id = 'deb460f8bdf09ad45d95999d810c3e974b94b2b80a665bb002da78dd5d2d8cc2'
AND (
token = 'zcJjY703NqEGDzsBpd7icKIBW7bL3Su0Dbo0N+HID8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)