UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNiqcqBrn7mViHBCuiCEymi0MRhIMK2Lg9vGIxOr0eU='
WHERE
key_id = '65809b6ad98acecf81d6653cd510fc59ad750330d8f3513488c4adc134a8dcf1'
AND (
token = 'zNiqcqBrn7mViHBCuiCEymi0MRhIMK2Lg9vGIxOr0eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)