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