SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '56ccf300b6de40869b0082f4ae08581402e59b1c9c276911ea2384e5064c31c1' 
  AND token = 'HtuA+sbAOfq8oPW/FJZusXzpNdqCXR9FQ20hWyYCdgw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00014

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}