SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8588bc5fed121fc5e1197423b5ad40c9c6a262e7943ee091e9facbd782a4d21c' 
  AND token = 'DLxs3TM15z+vkcuSqI8cGYrDahMFIB1x5cNTa2Ws2Ao=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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