SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '89018870d1b5f7cba5e5d111ba21ea161d153071933ef3ee91c34ee78a0e9561' 
  AND token = 'uN+M00hKH+y5cveh2ORcUbBBfMseDhj+V5N211gCAYU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00048

JSON explain

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