UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7TwsZz9emct9kEBoBBTtVeKmNQ1073JCPcsYFhtV4J8='
WHERE
key_id = '8a1649810d5b94a3c9370db065d99d8f96560c65abe27c1f1a66fffc72c03634'
AND (
token = '7TwsZz9emct9kEBoBBTtVeKmNQ1073JCPcsYFhtV4J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)