SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cdbce40cae5c0618aa1d0d7333a92358b7f7c06352c29b6e0b16b007ce6f1d3e' 
  AND token = 'n9BkDzk2IAmikKAJ8d4BDsA3BmzLLwdHwIQXkzMZYwE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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