UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9A0AaY0PrYz6cuU9CwHSZ+nc3LwW1pSjbD+Oohu29Q='
WHERE
key_id = '497596afb4eff0a9e1317ea0f2e0a0de25bb05f720267b06dcbfa5cd1dd64f4b'
AND (
token = 'x9A0AaY0PrYz6cuU9CwHSZ+nc3LwW1pSjbD+Oohu29Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)