UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fGP/6MQ9pCggkv/usY717v95sJRTVHb9zVgFM1lQ+3U='
WHERE
key_id = '1afbc4e600923284473b1dc9cacd62ac2fd270a415e64687f635659932390df7'
AND (
token = 'fGP/6MQ9pCggkv/usY717v95sJRTVHb9zVgFM1lQ+3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)