UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bwMjg1XDwjwYF5XIESJ73jmxI5Df2BHlWkTD4LM8XRg='
WHERE
key_id = 'c1c90a58fc0bfea7218a894b6c218d5a8b89e5eb1c5c75129a1548cab39a9a6a'
AND (
token = 'bwMjg1XDwjwYF5XIESJ73jmxI5Df2BHlWkTD4LM8XRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)