UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tMjP1gUCxW2c8o4qFps36BB2Rn3cj8woqHB6vacx12g='
WHERE
key_id = '81c71d98943d6946c0845f8f93976b78ad640b8985dc01c2fb576f5e35a204a2'
AND (
token = 'tMjP1gUCxW2c8o4qFps36BB2Rn3cj8woqHB6vacx12g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)