UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xPOPRbjJQE+EAtbFv6kkTgAsJ6SBD7+i7t4utEuCnL0=' 
WHERE 
  key_id = 'f8e2f6cd5222c90f47d961b178f86a4e8968989fd90f392fcd004299fa241132' 
  AND (
    token = 'xPOPRbjJQE+EAtbFv6kkTgAsJ6SBD7+i7t4utEuCnL0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025