SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cfb60fa049e438d521f8e0d2f719e96248260de1cee59568baeb02bc9cb2c6d2' 
  AND token = 'CdY2ZmH/H2DiVxzkwm/C8NpJ5GJFttkS1IiY2HOuUMA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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