UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gCRlVt0/Ykc1zqpPRyNN9Ipa0aOFwUAZs6NJ7+y1PWI=' 
WHERE 
  key_id = '3ea7384d77525690ced430a7162816402c936462722030c8864903f4f58eef88' 
  AND (
    token = 'gCRlVt0/Ykc1zqpPRyNN9Ipa0aOFwUAZs6NJ7+y1PWI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048