SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '157a3813ae252ca67494903d535aa2d9908e56ae8dd89d64852006d93d4f0a67' 
  AND token = 'PSkNa0fL1fWxnbHP0IAi6hHvMJjtCQUqFTUgeTgesTs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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