UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r5HWw5gImI6vMeUR/2QL2nWAvIe8yb1YuN+ijgenv5g=' 
WHERE 
  key_id = '6fc0707d58aa9e40e3e0f3c9542c5f5cf0de8941f4408253459099d6dda64650' 
  AND (
    token = 'r5HWw5gImI6vMeUR/2QL2nWAvIe8yb1YuN+ijgenv5g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026