UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R07LrzximgHnCmfffebvaR2dJTYzYDwlJN77jgZ0w94='
WHERE
key_id = '383b93a840818f269d543c798e89f7e23c6f9d9cdf470bb0819bb63b1d3f4eaa'
AND (
token = 'R07LrzximgHnCmfffebvaR2dJTYzYDwlJN77jgZ0w94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)