SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '46d83e34dcc9a8a330c6aa4211eaec81f677b50f2f40d97cc0dda5cc6feedba6' 
  AND token = '8rsdM+tpx1nJOT9xKDVGVtEjY/0qJ8o2/ltzTPDM5jQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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