UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nz3b0JEKABIQrjGDA2qydAWL2VIRo6MwW+s57G4vaFA='
WHERE
key_id = '12ae844f6be5087e49f10bd76c290f24f82f74b7eac46fd5536af908f6e6ac15'
AND (
token = 'nz3b0JEKABIQrjGDA2qydAWL2VIRo6MwW+s57G4vaFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)