UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnsU6iUDYQN3FIP2hbyEebZmI+MTRY8eoGNOR8Xys5o='
WHERE
key_id = 'c24e2cf48f896c6374a8f80ebc75ace272aaa83a476bb5745bb89793dcd7800d'
AND (
token = 'XnsU6iUDYQN3FIP2hbyEebZmI+MTRY8eoGNOR8Xys5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)