SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '202fade1330c0624198d4185a937a8b9077a9f6279f7d552c0302de8d6c1bc7e' 
  AND token = '0AjIQ+TpTHOi2x7rWXaPi44R/ElYAXeIkfyNgvbqs4c=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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