SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '77231e5f3badb85c786ffa383eeb35d3c0edc0c8135427e23c660d2a54f02312' 
  AND token = 'e4Tbb7j42ioOf/MAsjkOccqahZiu0i1y1Ta6vT4OT2s=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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