UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmPZN4WjJ5/eAd5YDSgA7Ha0VthtBrHCea4t3O1Ow2c='
WHERE
key_id = '738670e2b4efb12e6988f70613216cb48a12c6d1be92eb2e7755269ca73a09b1'
AND (
token = 'VmPZN4WjJ5/eAd5YDSgA7Ha0VthtBrHCea4t3O1Ow2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)