SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '846bcf8f132df51a686fdad0360b1736592bf26fb35dc9d0f6d153a7102e709e' 
  AND token = 'rc4+rXj7o363Gu3mFxnktM+S88MPCQ6R9Thrn3Y9L6U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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