SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e6b9b2b1c7072770994fb484cf9d203f93820ac2800b0195f1992c71811a005d' 
  AND token = 'xSQqlNhe3R1rXBcFQgaHsOEi36Pn6U9fH2XtZLq0Jfw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}