SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1f174a196851b6710cad07c9583d04cefc8a71b623f8dcf07801386b9c51d664' 
  AND token = 'Iy5s+OxGvT3+itjc9fx+qVlXuHOpcpjj0EerdUi30dE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00043

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}