UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FgDe8K8vepDSb3ISZsHmaAfAKABf6wELkxi0T1Bb+UU='
WHERE
key_id = 'cda2cac6311a8b67faa1e454624c7f40bd87e563a77097616c452c70e38b056c'
AND (
token = 'FgDe8K8vepDSb3ISZsHmaAfAKABf6wELkxi0T1Bb+UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)