UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/STfHjy10JICoVbJSNQ0fOZPxSYeEOPvxwnPN4BDa74='
WHERE
key_id = '296a368faaf2cdc846a4b180d20cc60970fab5998bdc08a433ef47cfcacf6247'
AND (
token = '/STfHjy10JICoVbJSNQ0fOZPxSYeEOPvxwnPN4BDa74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)