SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6938c0a0352c3d504704eb2acfb4bea3d18a223db8c8c5235d9ae5df6d9d6099' 
  AND token = '92D0Isz16cRF9PE87Op+fxZ+P4umVNAWsimNOzgFuZ8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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