UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcAwH7InvQF9gvXaqSV0555WCLtwgrNM0aw1i6fcDxo='
WHERE
key_id = '3b9115b4fe5c1ca461308507d90b9aee418d2ea3dcb35a7e2a3094571f4ce8b3'
AND (
token = 'XcAwH7InvQF9gvXaqSV0555WCLtwgrNM0aw1i6fcDxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)